Roll Number / Email: 24f1001831@ds.study.iitm.ac.in

Frequency count for "Sales" department: 12

Python Code Used:

import plotly.express as px
import pandas as pd

# -----------------------
# Dataset (with 12 "Sales")
# -----------------------
departments = [
    "Finance", "Marketing", "IT", "HR",
    "Sales", "Sales", "Sales", "Sales", "Sales", "Sales",
    "Sales", "Sales", "Sales", "Sales", "Sales", "Sales",  # 12 total
    "Finance", "Marketing", "IT", "HR", "Finance", "IT"
]

df = pd.DataFrame({"Department": departments})

# -----------------------
# Plotly Histogram
# -----------------------
fig = px.histogram(
    df,
    x="Department",
    title="Department Distribution"
)

# -----------------------
# Save HTML
# -----------------------
output_file = "output.html"
fig.write_html(output_file)

# -----------------------
# Extra info to inject
# -----------------------
roll_email = "24f1001831@ds.study.iitm.ac.in"
sales_count = (df["Department"] == "Sales").sum()

injection = f"""
{roll_email}

    Roll Number / Email: {roll_email}

Frequency count for "Sales" department: {sales_count}
"""

# -----------------------
# Read back own script
# -----------------------
with open(__file__, "r", encoding="utf-8") as f:
    script_content = f.read()

code_block = f"""
Python Code Used:
{script_content}
"""

# -----------------------
# Modify HTML file
# -----------------------
with open(output_file, "r", encoding="utf-8") as f:
    html = f.read()

html = html.replace("", injection + code_block + "")

with open(output_file, "w", encoding="utf-8") as f:
    f.write(html)

print(f"✅ HTML file generated: {output_file}")
print(f"   'Sales' frequency = {sales_count}")

import matplotlib.pyplot as plt
import seaborn as sns

# proof-of-work (same as in the script):
# sns.countplot(x="Department", data=df)
# plt.title("Department Distribution (seaborn)")